BEGIN TRANSACTION AddRegion1
	BEGIN TRY
		INSERT INTO [Region] (RegionCode, RegionName)
		VALUES (1, 'North Wales');
		
		COMMIT TRANSACTION AddRegion1;
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddRegion1;
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddRegion2
	BEGIN TRY
		INSERT INTO [Region] (RegionCode, RegionName)
		VALUES (2, 'South Wales');
		
		COMMIT TRANSACTION AddRegion2;
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddRegion2;
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddRegion3
	BEGIN TRY
		INSERT INTO [Region] (RegionCode, RegionName)
		VALUES (3, 'Midlands');
		
		COMMIT TRANSACTION AddRegion3;
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddRegion3;
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddRegion4
	BEGIN TRY
		INSERT INTO [Region] (RegionCode, RegionName)
		VALUES (4, 'South England');
		
		COMMIT TRANSACTION AddRegion4;
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddRegion4;
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


